Previous Topic

Next Topic

Posting Transactions for Multiple Warehouses

While the process of posting inventory transactions for multiple warehouses and standard inventory is the same, you need to be aware of the following when posting transactions for multiple warehouses:

Removing Warehouses

Once you remove a product's warehouse, you cannot post any outstanding, non-posted inventory transactions for that warehouse. If you post inventory transactions manually and remove a product's warehouse, all non-posted inventory transactions will be removed from the Post receipts window. However, non-posted inventory transactions will still display on the Enter and edit receipts and adjustments window (from Orders, select Enter and edit receipts and adjustments).

Inventory Transfers

Transferring inventory from one warehouse to another affects both product cost and inventory field values when a transfer is posted.

Cost of Goods Sold - Regardless of whether the Average or Standard Cost valuation method is selected when the Cost of Goods Sold option is enabled on the Inventory System Setup window, the following rule applies when posting inventory transfers:

The extended amount of the transferred product cannot exceed the current total cost of the From Warehouse.

If the extended amount of the transferred product exceeds the current total cost of the From Warehouse, then iMIS will perform the following calculations:

  1. The average cost of the From Warehouse will be multiplied by the quantity transferred in determining that the average cost does not exceed the total cost:
  2. If the average cost does not exceed the total cost, then the extended amount will be recalculated by multiplying the average cost by the quantity transferred. The unit cost of the transferred product then will be updated by dividing the extended amount by the quantity transferred.
  3. If the average cost does exceed the total cost, then the extended amount will equal the total cost of the product inventory. The unit cost of the transferred product then will be updated by dividing the extended amount by the quantity transferred.

Field Recalculation

The following fields will be recalculated when transferring inventory from one warehouse to another:

See Also

Posting Inventory Transactions

Post receipts window

To post inventory transactions


ASI logo 10.6 Production Release. Updated 7/15/2005 2:14:04 PM
Copyright © by Advanced Solutions International, Inc. All rights reserved.